Forum Discussion

admiralman's avatar
admiralman
Advocate II
8 years ago
Solved

Column Value based upon Cell (parsed)

I am using the folder data connection to bring in multiple excel workbook (specific sheet). Each one needs some basic cleanup but most importantly I need to add a column based upon the value in Row1 ...
Need Help
  • parry2k's avatar
    parry2k
    8 years ago

    here you go my friend.

admiralman's avatar
admiralman
Advocate II
8 years ago

I cannot...my company doesnt allow connection to those. Can you not generate a file quickly? I did that in about 1 minute. Sorry.

parry2k's avatar
parry2k
Super User
8 years ago

ok as you say, will do. cheers

 

  • parry2k's avatar
    parry2k
    Super User
    8 years ago

    here you go big boss. 

     

    Just created sample file from the image you pasted.

    • admiralman's avatar
      admiralman
      Advocate II
      8 years ago

      Could you provide the excel file you used?

      • parry2k's avatar
        parry2k
        Super User
        8 years ago

        here you go my friend.