0

To copy a column with a formula ?

Hi,

Can someone tell me how to copy a column with a formula ?

Thanks

31replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Nick
    • Nick
    • 1 yr ago
    • Reported - view

    Remove the dot (.) from this line

    delete last(select 'Tableau1-Tableau 1' where .'Chef op' = text(i))

    Like
  • 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 !

    Like
    • Nick
    • Nick
    • 1 yr ago
    • Reported - view

    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

    Like
  • Thank you Nick

     

    now I get 

    a column has not been found : Nom on the line 3, column 52

    Like
    • Nick
    • Nick
    • 1 yr ago
    • Reported - view

    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

    Like
  • Now I get a column has not been found : Chef op on the line 4, colonne 49

    Like
Like Follow
  • 1 yr agoLast active
  • 31Replies
  • 1909Views