Dataflow column mapping missing columns and disables primary key selection field
a week ago
I have a dataflow that copies data from one table (src) to another (dest). The src table contains 63 columns. I apply a filter to one column only and the results show properly along with the column count. However, after clicking next, and selecting "Load into existing table" and select my dest table, I only see about a dozen (subset) of the columns from the source table. I also don't get a chance to specify the primary key in the dropdown. It's completely greyed out. Does anyone know what the issue is or is this a bug?
@AhmedSalih I don't know for sure and I don't think I can now recreate the issue because I made several modifications to my dataflow that I can't remember all of them. But I was able to get around the problem after redoing my import and deleting all the unnecessary system columns I didn't need. I believe some of the columns that show as "Lookups" (and show as [record] or [Table] in the query editor) must have been the culprit. As soon as I cleaned all those up, I was able to execute my dataflow without issues.