none
Custom columns output RRS feed

  • Question

  • Hi 

    I did some custom columns and the output shows up perfectly in the PQ editor. However, when I export the output into the excel table or in the powerpivot data model, those custom columns show blank (as per below).


    Thanks

    https://1drv.ms/x/s!Amc8fiGpDxekhAxZhCWO-_ZQc4iS

    Start Time Finish Time

    Friday, May 24, 2019 6:10 AM

Answers

  • Hi,

    You should change two last steps:

        #"Changed Type" = Table.TransformColumnTypes(WICNUM,{{"CALLSIGN", Int64.Type}, {"Start Time", type text}, {"Finish Time", type text}, {"Final Wic Num", Int64.Type}}),
        #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Final Wic Num", null}, {"CALLSIGN", null}})

    • Edited by Aleksei Zhigulin Friday, May 24, 2019 11:31 AM
    • Marked as answer by M.Awal Monday, June 3, 2019 11:51 AM
    Friday, May 24, 2019 11:25 AM
  • Thanks for your assistance. It is interesting that time data type in PQ not being recognised in excel (output table) not being recognised neither as text or time data type. Even though it should be a time data type, it needs to change to text data type.
    • Marked as answer by M.Awal Friday, May 24, 2019 9:27 PM
    Friday, May 24, 2019 9:27 PM

All replies

  • Hi,

    You should change two last steps:

        #"Changed Type" = Table.TransformColumnTypes(WICNUM,{{"CALLSIGN", Int64.Type}, {"Start Time", type text}, {"Finish Time", type text}, {"Final Wic Num", Int64.Type}}),
        #"Replaced Errors" = Table.ReplaceErrorValues(#"Changed Type", {{"Final Wic Num", null}, {"CALLSIGN", null}})

    • Edited by Aleksei Zhigulin Friday, May 24, 2019 11:31 AM
    • Marked as answer by M.Awal Monday, June 3, 2019 11:51 AM
    Friday, May 24, 2019 11:25 AM
  • Thanks for your assistance. It is interesting that time data type in PQ not being recognised in excel (output table) not being recognised neither as text or time data type. Even though it should be a time data type, it needs to change to text data type.
    • Marked as answer by M.Awal Friday, May 24, 2019 9:27 PM
    Friday, May 24, 2019 9:27 PM