Forum Discussion

Nou_admin1's avatar
Nou_admin1
Frequent Visitor
4 years ago
Solved

Create Seperate Visual based on different column lookup

Hi Team,   Please suggest me a idea how to arrive solution for my working.   I have a Data sheet which contains the data for Managers, Executive and Reps in a single sheet with continues column w...
  • tamerj1's avatar
    tamerj1
    4 years ago

    It is also fine this way. It seems you have switched between the active and inactive relationships. You can do it either ways. But in order not to make mistakes I recommend you double check your relationships to confirm identidal to the sample file.

  • tamerj1's avatar
    tamerj1
    4 years ago

    Nou_admin1 
    Great!
    If you are satsfied with the result, I would kindly request you to mark my reply as accepted.
    Thank you!

Nou_admin1's avatar
Nou_admin1
Frequent Visitor
4 years ago

Hi Amit,

 

Thanks for your reply.

 

Here with I am attached the Download link of some Sample Data and Output Format. Please check and kindly suggest a suitable solution. Total 4 Sheet available 2 is Data sheet and 1 is master data based on master data the output needs to load as 1 sheet is for output sheet.

Download link

 


https://wetransfer.com/downloads/e1ea943aa1c06f70202fe6c645b340d720220301104911/eccc9c418a311d11248980c163fa7f8e20220301104925/b9b0fe

 

Thanks.