To copy a column with a formula ?
Hi,
Can someone tell me how to copy a column with a formula ?
Thanks
31 replies
-
Remove the dot (.) from this line
delete last(select 'Tableau1-Tableau 1' where .'Chef op' = text(i))
-
Thanks Nick
So I tried without the (.) on line 3 :
for i in select 'Tableau1-Tableau 1'.'Chef op' do
while cnt(select 'Tableau1-Tableau 1' where 'Chef op'= text(i))!=1 do
delete last(select 'Tableau1-Tableau 1' where 'Chef op' = text(i))
end
end␁
But when I click on the button nothing happens !
-
for i in select 'Tableau1-Tableau 1' do
let myDup := 'Chef op';
if cnt(select 'Tableau1-Tableau 1' where myDup = Nom) != 1 then
delete last(select Table1 where myDup = 'Chef op')
end
end -
Thank you Nick
now I get
a column has not been found : Nom on the line 3, column 52
-
Sorry my bad!
---
for i in select 'Tableau1-Tableau 1' do
let myDup := 'Chef op';
if cnt(select 'Tableau1-Tableau 1' where myDup = 'Chef op') != 1 then
delete last(select Table1 where myDup = 'Chef op')
end
end -
Now I get a column has not been found : Chef op on the line 4, colonne 49
Content aside
- 3 yrs agoLast active
- 31Replies
- 2025Views