Hello all,
I'm new to Alteryx and an experienced Access user. In Access if I create a query using two tables with no fields in common (for example: One with 50 states and the other with 100 products), if I don't join the two tables and run the query, the results will show every combination of State & Product, i.e. 5,000 records. I tried using the Alteryx "Append Fields" function, but received an error message ("Error: Append Fields (4): There were more than 16 records in the source") and the results were only partial.
How would I do this in Alteryx? Many thanks in advance.
Solved! Go to Solution.
Thanks, that's all I needed to do!
Thanks Neil. but the append field duplicating the values. I want the output as shown in the pic. how to do this?
do we have any solution for this?