Forum Discussion
brezendelima
Dec 19, 2022Copper Contributor
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
- XXploreBrass ContributorSounds 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 - peiyezhuBronze Contributorthe Group matches in both ends.
after import to Excel,have you tried xlook formula?- brezendelimaCopper Contributor
peiyezhu no, I haven't tried it, but I'll look forward to it, thank you.
- brezendelimaCopper ContributorI've tried the formula, unfortunately it wasn't enough to solve my problem. I'm still looking forward to it yet.