Forum Discussion
power query
hello I have an issue with collecting data from multiple CSV files
I have several CSV files that have the data in vertical order with heders in column 1 and data in column 2.
I need to program a query to collect the data from all the CSVs that I put in a file, take the data from each column 2, and present them to an excel sheet in lines.
The problem is that when it takes the decimal numbers it removes the decimal point "." and the numbers are wrong
4 Replies
Hi pchazirakis ,
Can you provide examples of what your raw CSV data looks like, clarify whether the CSV files hold the same type of data in the same structure as each other, and provide an example of what you want the final output to look like please?
Pete
this is the csv file
and the result i take is
Hi pchazirakis ,
Are their column types Whole Number or Decimal Number?
I have a simple test on my side, everything works fine. My PBI version is the lastest one——Version: 2.102.845.0 64-bit (February 2022)
Could you please share me with your CSV or pbix file after removing sensitive data to help us clarify your scenario?
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.hello thanks for all your help I'm not very familiar with coding
my goal is from multiple CSV files with the below configuration to collect the second column make it vertical and make a table with the above values
I have made it to create the table but the numbers are not recognized the decimal point is deleted, the issue is that if the number is "0.014" it is transferred as "14" to the table if the number is "1.4" it is transferred as "14" and etc.
I need a step to replace the "." with "," in all the CSV files. I mast mention that the "," is used to separate the columns
below I have the data from the CSV file :
start of CSV file
Test Name,MANUAL_107
Test Start Time,09:14:49 AM
Mass Average [mg/m3],0.036
Mass Minimum [mg/m3],0.033
Mass Maximum [mg/m3],0.039
Elapsed Time [s],Mass [mg/m3],Alarms,Errors
10,0.036,,
20,0.037,,
30,0.039,,
40,0.039,,
50,0.038,,
60,0.037,,
70,0.036,,
80,0.035,,
90,0.034,,
100,0.033,,
110,0.034,,
120,0.035,,
130,0.035,,
140,0.035,,
150,0.038,,
160,0.037,,
170,0.035,,
180,0.035,,end of csv file
the result I want is a table like
