Announcements
Hi
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?
thanks!
Hello, @maxpower45255 , are you only missing the System Columns or the custom columns as well?
@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.
I hope this helps others.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 993
Valantis 675
11manish 545
