All Apps and Add-ons

When imported the Lookup file with the Looup editor, some records become NaN

Watanabe
New Member

I imported the lookup file using the app Lookup Editor.
The record of the column whose column name is only numbers was NaN.
(Normal values are values such as 1A or 4A etc, but those values are all NaN after import)

Currently, we were able to update with the following measures.
1. Change the column name of only the numerical value of the file before import to a character string and import it.
2. After importing, change to the correct column name.

Since this correspondence is a provisional correspondence, I would like to solve the problem that the record changes to NaN.

Sorry, If there are people who know how to solve this problem, please reply.

Lookup Editor
version:3.4.6
build:1595011574

Kind Regards,

Labels (1)
Tags (1)
0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Reprocessing XML into Fixed-Length Events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Data Management Digest – December 2025

Welcome to the December edition of Data Management Digest! As we continue our journey of data innovation, the ...

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...