How to use datasets with duplicate column names in a dataflow
Using a JIRA connector, I import a dataset, which has a 1000 columns. There are two columns which have duplicate names. Consequently, I cannot use the dataset in a Domo SQL transform as it gives me a duplicate column error. I also cannot write each column name individually as there are 1000 columns (and I need 999).
Is there a way to use my dataset in a transform, while catering to the duplicate column issue?
One solution could be selecting all columns in my table except one. Is there a way to do that?