Hi All,
Anyone can help me to set the data record below based on the data in cell to make it as a Header.
For example in the image above I want to set the header if data records is equal to "Debit Sample" so however the Debit Sample data place my header will always set to it.
TIA,
Solved! Go to Solution.
Hi @arjundelara
One of the way would be to set the line from which it should start reading this can configured in input tool.
Hope this helps 🙂
Hi @atcodedog05 ,
It is Static. What if the future file for the next month is set upper or lower records, how can I get the set the dynamic records based on the data in cell.
Thank you!
Hi @atcodedog05 ,
Attached file is my sample input. the enhancement is what if the column contains "Debit" is place in lower or upper row.
Thank you!
Highly Appreciated.
Hi @arjundelara
Would this meet your requirement. It dynamically takes the row name after filtering nulls.
Hope this helps 🙂
Hi @atcodedog05 ,
I have an update to this file. Now the problem is to get the data between of the contains column for example I want to gather the data from [Field] contains "Debit" to [Field] contains Credit and the output is all of data between that will captured.
Thank you!
Hi @arjundelara
I hope this works. This blocks and captures the data only in between
Hope this helps 🙂
Hi @atcodedog05 ,
Great Workflow simple but perfect.
Thank you so much! Have a nice day, Hope I'll help you too soon!
Cheers,
Happy to help 🙂 @arjundelara
If not me I would definitely encourage you help others in your free time.
Cheers and Happy Analyzing 😀
Feel free to reach out if you face any issues 🙂