Using variable instead of "A", "B" etc. in write cell activity

Help Studio
, ,
1

Hi all :slight_smile:
How can I define a variable which can be used instead of “A”, “B” etc. indicators of columns in “Write cell activities”?

I would like to use name of headers as indicators so every time I change headers name, add or remove column “Write cell activity” would work. I desperately want to get rid of the “D” index :smiley:
image

Thank you in advance!

2

Hi ,

Use lookup range activity with the column name and it will return the column index. Use the substring method to pass only the column index to the write cell activity.

HAPPY AUTOMATION !!!

3

Hi @Krishna_547 ,
It works! Thank you very much!

4

@Piotr_Murawski CHEERS !!!

5

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.