Dynamic Column
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,329 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,329 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.