How to set a variable range in output data tool

Question

I have excel sheets, sheet1 and sheet2. I use output tool's overwrite sheet/range option to overwrite columns from sheet1 to sheet2.

Currently my range looks something like :-

|||sheet_name$A1:AP3162

I want the end row number range to be dynamically set instead of typing something like 3162

Also sometimes the number of rows in sheet2 are more than sheet1 and vice versa, so ideally I want it something like :-

|||sheet_name$A1:AP[var1 +var2]

where var1 and var2 are the number of rows in sheet1 and sheet2 respectively.

But I'm not sure about the syntax needed to implement this. I looked it up and couldn't find anything in the documentation for the output tool either.

alexnajm · Answer

As long as the variable is available in the data, you can reference it in the Formula. If it doesn't exist, you need to create it!

If you give more detail, we can help further - without seeing the workflow/data, it's hard to help

vj28 · Answer

I still don't get it, what would the syntax be if I wanted to use a variable in the path? Where would I need to declare and initialize said variable? Perhaps this is too basic a question, but I'm new and the documentation doesn't seem to detail this anywhere. Thanks.

alexnajm · Answer

Like you alluded to, it'll be "|||sheet_name$A1:AP"+ToString([Count])