Join Column row names from the same table

Question

Hi Everyone,&nbsp;I have a table (quote log table) that only shows me the name source (user table) of who had created a quote when a quotelog has gone through S1 = status 1&nbsp;&nbsp;&nbsp;&nbsp;I want to be able to still see the name source of who created that quote when the same quotelog has gone through a count of S9= Status 9&nbsp;&nbsp;Problem is that the only time i can see the name source is when a quote has gone through status1, after that, the name (from the user table) disappears and all the quotelogs that follow of that quote ID will not have a record of the name.&nbsp; &nbsp;&nbsp;How can i make it so that each of these quote ID's always show the name source, even if i dont choose "status1"&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to help me see it.&nbsp;&nbsp;Thanks in Advance!&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi Everyone,&nbsp;I have a table (quote log table) that only shows me the name source (user table) of who had created a quote when a quotelog has gone through S1 = status 1&nbsp;&nbsp;&nbsp;&nbsp;I want to be able to still see the name source of who created that quote when the same quotelog has gone through a count of S9= Status 9&nbsp;&nbsp;Problem is that the only time i can see the name source is when a quote has gone through status1, after that, the name (from the user table) disappears and all the quotelogs that follow of that quote ID will not have a record of the name.&nbsp; &nbsp;&nbsp;How can i make it so that each of these quote ID's always show the name source, even if i dont choose "status1"&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;to help me see it.&nbsp;&nbsp;Thanks in Advance!&nbsp;&nbsp;

vivran22 · Answer

Anonymous&nbsp;&nbsp;Hi,&nbsp;In Edit Query mode, you can use the "Fill Down/Up" feature to get the desired result.&nbsp;Thanks,Vivek&nbsp;If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

vivran22 · Answer

Hi,Did this solve the issue?Rgds,Vivek

Forum Discussion

Join Column row names from the same table

3 Replies

Related content

Changing lakehouse table column names

Column data = table name

Dynamic Column Name

Delta Table Column name length

Schema Name for Tables