Appended Query. Dates are not capturing in other columns

Question

(PDate)&nbsp;Hi guys, i have a Date column named (PDate) and when i append query from 4 other tables, the dates column from these 4 tables didnt show any value. Is there a way to solve this?&nbsp;

amitchandak · Answer

Anonymous , All you dates seem to have different name. So that will show limited data(Only for the tbale have that name). Can you rename them before append

amitchandak · Answer

Anonymous ,All you dates seem to have different name. So that will show limited data(Only for the tbale have that name). Can you rename them before append&nbsp;

anonymous · Answer

I have renamed all the dates columns to PDate in the 4 tables as shown below.

I have Appended the Query

#"Appended Query" = Table.Combine({#"Removed Other Columns", #"100%", TR, #"Cash Book", Loans}),

However, it still doesnt work that way. It is not reading per row.

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
Could you please provide some sample data from the 4 other&nbsp;tables? If possible, it would be better to share your simplified pbix file. Later I need to check how you append these tables in your pbix file.
I created a sample pbix file(see attachment), you can refer it to append the tables. 
1. Rename all of the date field in other 4 tables as "PDate"
2. Append these tables

Best Regards

anonymous · Answer

Alright, i will try and let you know the result. Thanks anyway.

Forum Discussion

Appended Query. Dates are not capturing in other columns

6 Replies

Related content

Dataflow - Append

Appending columns and creating new column of old column headers

Appending Data

Append Column to row derived from the from three columns

Append Column to rows derived from the from two columns