Forum Discussion
bhaskarpbi999
2 years agoHelper V
Group data and create columns for weekdays and Time values
Hi All, I need your assitance to shaep the data to the expected format. Current Data Format Expected result the Week days needs to be columns and Time should be like below. ...
- 2 years ago
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("zZXJCsIwEIZfZeg5atKKbb2JCxZcilY8VA8BFyJpKq2+v3VARIxHyVwmmZDl48vhz3NPiCCMPeYNy+qmLkrrsob1VSrTrI2mM0gHs/lyMV4z2FU7M+zAqJJnWSgjawYiYpCWug2JObQhlboozbGGJMHNr6PY4Ds483kARXO7uWv9HoS3Zy5p5sum8LDPeYtHTSWDFD+RRJcQkughEhFL2YacJUSiZWk7JmcJkWhZyqbkLCESLUuTFTlLiPTDUvTsMlmpk/w3TRD7oSXbfJcolhRxz/P5VU55LPnhnoeQH0tyuOch5MeSGe55CPmxpIV7ni8/+wc=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Postal = _t, #"City Country" = _t, #"Collect Point" = _t, Date = _t, Time = _t, Index = _t]), FilteredRows = Table.SelectRows(Source, each ([Date] <> "null" and [Date] <> null)), GroupedRows = Table.Group(FilteredRows, {"Collect Point", "Date"}, {{"All", each Table.AddIndexColumn(_, "ID", 1, 1, type text), type table}}), CombinedAll = Table.Combine(GroupedRows[All]), AddedPrefix = Table.TransformColumns(CombinedAll, {{"ID", each "Time" & Text.From(_), type text}}) in AddedPrefix
bhaskarpbi999
2 years agoHelper V
Hi dufo,
Thanks for your prompt response and i have pasted the data table.
Thanks for your support.
Regards.
Bhaslar
- dufoq32 years agoCommunity Champion
It is a screenshot.
- bhaskarpbi9992 years agoHelper V
Postal City Country Collect Point Date Time Index 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 m1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mMO 09:00-14:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mMO 16:00-18:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mTU 09:00-14:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mTU 16:00-18:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mWE 09:00-14:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mWE 16:00-18:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mTH 09:00-14:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mTH 16:00-18:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mFR 09:00-14:00 1 11379 Cortijillos Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
203 mFR 16:00-18:00 1 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 m2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mMO 09:00-14:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mMO 16:00-18:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mTU 09:00-14:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mTU 16:00-18:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mWE 09:00-14:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mWE 16:00-18:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mTH 09:00-14:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mTH 16:00-18:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mFR 09:00-14:00 2 11380 Tarifa Spain DHL PALMONES,
C/ Dragaminas, 18, Pol. Ind. Palmones II
PALMONES
11379
23927 mFR 16:00-18:00 2