How to store a Main_DT which contains Nested_DT inside for future reference?

Help Studio
, ,
1

HI team,
I’ve a scenario where i want to store a Main_DT which contains certain Nested_DT inside. The process performs step1 today and creates Main_DT. This data then needs to be picked up by same process at a later stage after X days. So where can I store this Main_DT for the step 2 of the process so that it can get the same Main_DT.

Tried excel but it only stores Main_DT and not Nested_DT data. No option to push this Main_DT to asset also so how to preserve this DT for future usage? Please advice.

2

@tejaskumar.darji

storing in excel should be ideal..can you show how the data looks and what issue you are facing with excel?

might need little pre processing

cheers

3

As i mentioned it contains nested DT inside main DT so excel isnt the right way!

4

@tejaskumar.darji

if you can show the data that would help us understand and give a solution..

as already mentioned little pre processing might be needed

something like storing nested dt in separate sheets and while reading merge them again

or serialize whole variable and store as text file and then read it and deserialize it back to datatable

cheers

5

Better to share a sample data so that we could explore more options