Dynamic generate fields based on result of one field

[blin]

Hi,

I am new to Alteryx and wondering of I can generate an output file as showing below.

On the right side is the source data for item related data. All fields are identical, in different season.

I would like to set up a work flow that will:

1. combine the source files and output identical field side by side using the value of the season field as prefix to distinguish which file the data is from.
2. Can I also set up condition formatting to highlight difference. For example, same item# with different HTS# in different season or same HTS# with different Duty Rate in different Season.

[blin]

HaHa, no problem at all, I know I throw in a lot of extra questions... I would accept the answer this time. Thank you for your effort.

I am looking for documentation that I can print out so that I can review them when I am not even on my computer. I think that's faster for me to train myself think the way Alteryx thinks....

I like to have an overall picture of what available and then going detail on each topic. When you use the search in the built-in Sample you start with each topic first, which is hard for beginners as they don't even know what's out there and would take a lot of time just searching and reading.