Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Dynamic Column
Added on February 17, 2025 9:02AM
Likes: 0
Replies: 3
Poornima
Registered Posts: 4 ✭✭
I have an excel input file. Col A to Col T till row T26, I have data where Col T have latest month data. Col V to Col AO have second set of data till AO50. Now, its dynamic data, every month, a new column is added. For example, for next month, Col u will have Dec month's data. same with second set of data, I will be getting data in AP.
Can anyone guide on utilizing this data without Python
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,345 NeuronNot posible without Python. Ask your data producer to produce a proper CSV file where month data in rows not columns so it won’t need to change for new months. Or use Python to load it. Those are your choices.
-
Can this is be done using RegEx? @Turribeach
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,345 Neuron
No. This has nothing to do with Regex. File based Dataiku datasets use fixed data type schemas. If the file changes you have to manually update the schema. Only Python recipes can write dynamic schemas as their output. And even doing so will complicate your flow so your best option is to pivot the data so months are rows not columns.