topic How to Create dummy columns or create columns manually in Data & Schema Discussions

How to Create dummy columns or create columns manually

KHK — Mon, 03 Jul 2023 15:09:56 GMT

Hi ,

I have below excel file data. Data entered manually and has no source for this data.

User don't want to upload this file for small data.

I have metric like if Id=1, then amount, if Id=2, then revenue etc.

Also using column B values as prompt values in dashboard to filter the data. This is the requirement.

Any way to created these columns in Incorta using Session variable or presentation variable? or any other way to create?

RADSr — Mon, 03 Jul 2023 16:46:55 GMT

RADSr — Mon, 03 Jul 2023 16:58:12 GMT

That said, I genuinely cannot think of a legitimate argument against uploading an Excel or CSV with those values.

Is the objection as simple as they don't want to do the upload? If so, can you do it yourself?

In any case, the linked solution will work for you.