Hi Guys,
i have 2 tables:
1.t_source
2. t_tiers
and i want to achieve the result like in screen and excel attached.
So as you can see i have to merge 2 columns into one (ABY Server Type & BRO ServerType AND ABY Number & BRO number), add specific tier group to topology as column and finally get result like in screen above.
How can i do this?
Please help,
thank you in advance
Jacek
Hi Jacek,
Welcome to the forum. Thanks for sharing a sample file.
Please see attached. Note: since there is no common column between the two tables I've matched the Tier Group so that it alternates between ABY and BRO as there is no other logic I could see.
Mynda
Wow thank you Mynda !
i understand your steps, awesome!
Have a question regarding using index and refering this to tier group.
It can be also done by text?
I mean in tier group i have only 2 items, but if i will have more (for example 4) i think the index function will not work.
Best,
Jacek
Ok,
i know where is mistake.
Sorry, for source table i should provide something like in attachment.
Maybe now i can somehow refer to table with tier group?
I mean to use Topology as joined field, can you help with this?
I added new Excel example.
Best,
Jacek
Hi Jacek,
I can't open the revised file. Can you please upload one with a different name to the original.
Mynda
Hi Mynda,
thank you.
I attached the file.
btw. this forum is awesome!
Best,
Jacek
Hi Jacek,
Great to know you're finding the forum helpful. Please find attached. Note: these techniques are all covered in my Power Query course.
Mynda
Thank you Mynda,
awesome!
If i would get founds from my Employer i will buy this course,
All is working!
Great knowledge!
Thank you,
Jacek