0

To copy a column with a formula ?

Hi,

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

Thanks

31 replies

null
    • Nick
    • 3 yrs ago
    • Reported - view

    Remove the dot (.) from this line

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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    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 !

    • Nick
    • 3 yrs 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

    • saddinsell
    • 3 yrs ago
    • Reported - view

    Thank you Nick

     

    now I get 

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

    • Nick
    • 3 yrs 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

    • saddinsell
    • 3 yrs ago
    • Reported - view

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

Content aside

  • 3 yrs agoLast active
  • 31Replies
  • 1999Views