Can you add headers to tabs created by using the append range function?

Help
1

Hi all

I use write range to create a spreadsheet and coz I select ‘add headers’ my two headers of ‘Product and Price’ are created. I then use Append Range, to add tabs to this spreadsheet, but I can’t find a way of creating headers for each of these new tabs I create. What is the best way of doing this, please?

Thanks
Jordan

1 Like
2

Fine
Create a datatable using build datatable activity where we can create a datatable with two columns we need and get the output with a variable of type datatable
—and we can pass the same to append range with that datatable

But I would suggest to go for write range activity passing the same datatble created with Add Headers property enabled in the property panel, instead of using append range activity

Simple isn’t it
Hope this would help you
Cheers @jordrowley

1 Like
3

Thank you @Palaniyappan, as usual!

4

hey @Palaniyappan, can I ask you for some split string function help please?

1 Like
5

yah sure, anytime
Cheers @jordrowley

6

Thank you!

I have some data like this (for example)

“£1.21£1.23
£1.21 per kg”

or like this (for example)

“35p40p
£1.21 per kg”

And I need to loop through and get just the ‘current price’ which in the above two examples would be £1.21 or 35p.

I’ve tried splitting the data in to an array of two lines (e.g £1.21£1.23 and £1.21per kg" then using an IF function to see if the first line of the array contains either a ‘£’ or ‘p’ and then using a string split function to isolate the value I want but I’m having problems.

Please can I ask what code you would write to get the price?

Thanks :slight_smile:
Jordan

7

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