Forum Discussion

brezendelima's avatar
brezendelima
Copper Contributor
Dec 19, 2022

Conditional import from txt or csv to Excel

Hello, so, I need to import data from a .txt file (might as well be a .csv) that contains: "Initial date", "Final date", "Group".

In my Excel sheet I have empty date cells that must that must be written with the dates contained in the .txt file and it only must be written if the Group matches in both ends.

I tried importing them using the data importing tool, but I couldn't find a way to make it conditional.

Any ideias on how I could solve this problem?

 

  • Sounds like Power Query works:
    (1) Goto Tab Data->Get Data->From File->From Text/CSV
    (2) Select source file t-> "Transform Data" -> PowerQuery Editor
    (3) Transform the data, e.g. "Use First Row as Headers" -> Add "Conditional Column"
    (4) Edit condition, Filter By Contional Value, Apply & Close

  • XXplore's avatar
    XXplore
    Brass Contributor
    Sounds like Power Query works:
    (1) Goto Tab Data->Get Data->From File->From Text/CSV
    (2) Select source file t-> "Transform Data" -> PowerQuery Editor
    (3) Transform the data, e.g. "Use First Row as Headers" -> Add "Conditional Column"
    (4) Edit condition, Filter By Contional Value, Apply & Close

  • peiyezhu's avatar
    peiyezhu
    Bronze Contributor
    the Group matches in both ends.
    after import to Excel,have you tried xlook formula?
      • brezendelima's avatar
        brezendelima
        Copper Contributor
        I've tried the formula, unfortunately it wasn't enough to solve my problem. I'm still looking forward to it yet.

Resources