Record group loop on excel

[VictorChia]

Hello,

I have a workflow with python script & XGBoost which running continuously untill the group set end (within the group loop rules). I wanted to record the group loop variable so i can know what’s the data represents to in my excel. Is there any idea how to record & write the variables?

So eachtime the workflow set is writing the result in excel, it also write which variable it’s running

Thankyou in Advance.

Regards,
Victor Chiarouven

[AlexanderFillbrunn]

Hi Victor,
Where do you want to write the variable value? Into a new tab in the same Excel file, in the file name of the Excel file (example), or into a completely separate file?
Kind regards,
Alexander

[VictorChia]

Hello Mr. Alexander,

Thanks for responding my post.

I would like to write the variable value on the same page as my prediction result in a new column. In my workflow, I append all the result in the same excel, and I wanted to record each variable besides its results.

Thankyou!

Regards,
Victor

[takbb]

Hi @VictorChia , you can append one or more variables as new column(s) on the existing data set using Variable to Table Column. Just include it prior to the Excel Writer node. The flow variable port on this node is optional, and you only need to join to the variable port if the source of your flow variables is a different “branch” to the one containing the data.

[VictorChia]

Dear Takbb,

Glad to hear the idea from you, I will give it a try and will back here later.

Thankyou!

Regards,
Victor

[VictorChia]

Dear All,

The issue has been solved, thankyou!