Geological Model

CHARLESGLEVERCISSE
CHARLESGLEVERCISSE Posts: 7
in Leapfrog

Hello,

is it possible convert lithology into number? e.g i have a 30m granite from 0m to 30m and i would like to code GRANITE as "1" so that instead of granite it will "1" in new calculation column but the result will be 0-1m=1, 1-2m=1,………29-30=1m?

Comments

  • JamesLally
    JamesLally Posts: 29 Calcite Rank Badge

    Yes, you can make a Numeric Calculation using an IF statement to assign a number value to a text column within Leapfrog. If you want to assign multiple lith codes then the IF statements need to be nested (see example below). For many codes it's easier to do this with a VLOOKUP statement in Excel or as an UPDATE query in MS Access and then import the new column back into your Leapfrog project.

    image.png

  • CHARLESGLEVERCISSE
    CHARLESGLEVERCISSE Posts: 7

    Thanks you so much

Categories