Alteryx to update one record of common Table in every Record ID table /page

[Prasant]

Hello All,

Looking for a solution, I have 10 separate Records of table which publish in 10 separate page but there is one common table will be share with every page, can anybody help me !

I tried to create 10 similar tables from one original table by putting record ID but not working, table get create but contents not coming! can anybody quickly support me!

ex.

Table 

1. Company A 

2. Company B 

3. Company C 

4. Company D

5. Company E

Table

6.Currency Z 

Table 6. Currency Z will be attached with all the above 5 tables excel sheets!

as like below

Table 

1. Company A + 6.Currency Z

2. Company B + 6.Currency Z

3. Company C + 6.Currency Z

4. Company D+6.Currency Z

5. Company E+6.Currency Z

[apathetichell]

Are you having trouble joining Z to 1-6? If so can you post some data samples? It seems like 1-6 are pretty much the same whereas Z has a different type of data. Isn't there a common column that you can join on?

[Prasant]

Hi,

Thank you for your quick response.

i have attached set of example, in Group company list there is 5 company table, another sheet Z contains monthly data table which will place in every sheet beside to table!

I am trying to create 5 numbers of Z table so that I can attach each page A, B, C, D, E

here I am stuck,I applied Record ID but it is not creating 5 tables including the same contains!

let me know if you have any further question, I will really appreciate your help

[Prasant]

hi, no there is no common in z data and A-E Data, there is a common in A-E Data but Zdata not, completely different but I have to create the same numbers copy of Z Tables as Group company get increase

[apathetichell]

O.k. - as I'm seeing this you have 5 group company sheets and one monthly data sheet. Are you trying to attach the monthly data sheet to each company sheet? - ie every sheet gets the same monthly data? It also seems to me like your company specific sheets will have to be pivoted and have some work done to get them into a usable format.

You could just append sheet z to sheet a-5 assuming that Z is the same for each sheet. If Z is not the same for each sheet you need to have a methodology for which parts of Z connect to which parts of A-F.

[Prasant]

thank you, let me try Append sheet

[apathetichell]

It may look like bad because instead of having one row per entry - you have three or four - and each one will get an append field. In your situation it would make sense to first create single seperate lines form each sheet and then join the data.

note - if you just want to it be parallel ie:

sheet A sheet Z

you'd use union - config by name and allow all joins (assuming no two columns have the same name).

[Prasant]

Thank you, 

I got another way doing multiply of the table,I used the Multi-Row Formula tab, and working well