Need help to create more than one association

Anonymous — Tue, 31 Jul 2018 05:56:44 GMT

I am having my data in 8 different sheets in SQL database. In all these sheet 2 columns ( Date and Node Name) are same in every sheet. I want to create two simultaneous associations 1 for date and 1 for node name so that I can filter based on selection and all my related output will keep changing based on any of this filter selection

Can anyone help me

Thank you

Prasad

Re: Need help to create more than one association

felipedl — Tue, 31 Jul 2018 17:30:53 GMT

Hi Prasad,

Is the data independent on every table or does it have some sort of correlation?

Say, sales and proposal would have keys that are related, so you could have them linked by a common key (let's say [Node Name] and [Date]) and make all the associations follow the same rule.

Or they could be excludent, say HR info and Sales Orders, and for that case you could create a linktable with the concatenated fields from each table do denote each information individually.

Additionally, since you have them linked by the key, you would be able to take those fields of the individual tables, so that only a central table contains all the possible variations.

topic Need help to create more than one association in Connectivity & Data Prep

Need help to create more than one association

Re: Need help to create more than one association